
DROP TABLE IF EXISTS hdp_lbg_supin_zplisting.dwd_zp_husky_n_task_runtime;
CREATE EXTERNAL TABLE hdp_lbg_supin_zplisting.dwd_zp_husky_n_task_runtime (
    inst_id BIGINT COMMENT '定义dp中的执行instID',
    task_id BIGINT COMMENT '对应的taskID即 scheduler_id',
    job_state BIGINT COMMENT '510运行失败 400 运行成功  600用户取消 300正在运行',
    type INT COMMENT '1-每天自动运行，2-代表手动调起重跑，3-代表单独运行一个Job',
    run_time STRING COMMENT '业务运行时间参数',
    execute_time STRING COMMENT '开始执行时间，对应excute_time',
    update_time STRING COMMENT '执行结束时间,正在运行300,与execute_time相同',
    job_id BIGINT COMMENT '对应Yarn中的appID',
    job_name STRING COMMENT '对应Yarn中的appName',
    retry INT COMMENT '重跑次数默认为0',
    create_time STRING COMMENT '创建时间'
) COMMENT 'DP任务执行详情表'
PARTITIONED BY (dt STRING)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' COLLECTION ITEMS TERMINATED BY ',' LINES TERMINATED BY '\n'
STORED AS TEXTFILE LOCATION '/home/hdp_lbg_supin/resultdata/hdp_lbg_supin_zplisting/dwd/dwd_zp_husky_n_task_runtime';
